SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19689 LIMIT 1 [ RunTime:0.001433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19689 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49998,516410,612504,745969,917779,884464,257993,419559,528414,155081,993529,590589,572245,231976,309767,866050,699994,476760,229185,237269,671435,909060,201765,384259,975982,5082,816052,435990,408964,723699,406883,400926,643762,1002147,800316,1030985,776112,827701,291198,1045668,375217,307649,785074,38167,436907,97593,287187,955991,316381,1320,1020521,2544,696306,883119,177106,507888,898643,806994,137310,548894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]