SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5193 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5193 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912311,520212,164609,740156,490220,671484,151841,808331,527138,947621,559164,1033311,17806,671714,440093,590289,152094,465283,1010231,380433,581617,244551,624051,719487,235316,519775,680347,85017,778957,842667,143640,218224,308956,903807,549622,101268,618119,822820,178499,314420,970179,645606,413149,287974,795806,297130,928684,666074,805466,318367,677691,551008,533088,32307,793881,588465,850358,529667,863932,28271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]