SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49940 LIMIT 1 [ RunTime:0.001006s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49940 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709071,995330,137762,931966,860237,938690,101931,338902,283543,1018192,569588,1039742,476179,685022,226790,428072,585318,78539,95667,563357,57120,244553,395936,828325,236570,952093,561146,36289,736130,479479,69876,991725,867426,694451,480495,415917,542596,925240,169641,601441,279499,64010,229369,650000,811738,746518,187359,891027,351186,438844,303575,478234,922118,464260,82362,774623,947805,9179,945608,717891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005408s ]