SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005432 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005432 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183410,120368,1015082,304515,202386,147015,119181,842807,208899,779813,811049,506403,62915,329222,263574,3522,444611,662250,171240,1039888,750445,212801,16940,535819,268520,395616,779920,738020,709256,505733,146263,573592,58502,691690,730333,447055,408027,62639,815517,447333,591725,780655,589228,824991,203035,301595,928641,1014673,678124,470585,210368,1036149,23340,999534,602143,889613,1036311,221051,418390,680959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]