SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522271 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522271 [ RunTime:0.006243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559865,822197,184113,1035234,670734,100559,408492,490458,251122,489254,918205,794043,40389,637484,648968,866516,722467,854755,279162,580430,727918,481619,801259,751302,1037798,541839,346401,752210,980904,36832,213646,550736,861057,207083,1012175,705891,438605,414160,524233,88312,935183,700093,568939,842007,689153,533931,610637,934126,863283,214504,211281,1033262,457691,720311,234510,127768,215806,19213,890286,396077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002609s ]