SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003021s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535831 LIMIT 1 [ RunTime:0.000765s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535831 [ RunTime:0.004166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843314,141568,602220,848953,505268,900277,719195,922435,785194,566814,485089,1000925,889700,403785,70340,735076,488182,665464,907373,363171,37348,839637,40884,504234,728046,365580,134566,36418,1024320,293406,668142,179100,370489,83462,741477,1035488,475421,519424,97972,33406,655721,788593,282690,453915,894510,779409,115740,749833,1027327,420482,867055,558737,458911,620151,282831,994788,984163,582858,749845,568591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001105s ]