SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534435 LIMIT 1 [ RunTime:0.001237s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534435 [ RunTime:0.003420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432273,161200,507477,749880,158723,931052,465782,845840,53933,627875,993422,1048380,212630,1037331,198879,425593,485983,804555,726203,698048,61919,484144,689180,208215,556744,817943,140079,702285,160343,649279,668977,971392,288354,748817,761557,627494,1048715,91362,452566,621464,971844,827102,548071,640445,889349,501108,118504,449820,231908,256084,353085,85487,934953,250175,505408,526642,370222,446029,781270,440205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]