SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042141 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042141 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314178,1030994,105456,916063,164296,907449,1012437,820206,998799,226864,26192,339330,538851,462986,469919,997529,672676,1004405,236018,64640,139989,127387,188811,74435,651983,581753,322014,745986,459582,502400,270557,845739,487176,62793,411168,27262,299118,29505,270832,741445,889555,499507,387324,59588,405264,119743,999739,1012536,573831,181990,237955,201687,321368,632336,644274,815957,671935,2724,452463,113793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]