SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102654 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102654 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046435,91440,301401,863886,197967,761868,143088,879884,483506,102895,119716,277833,826765,274904,829019,78839,332120,796114,274105,663424,906451,928978,243707,929412,138070,122774,50138,144402,688851,641096,1012638,611296,1002512,496453,525290,70693,527243,502134,60471,551223,518909,424017,338998,572350,410902,753597,920247,384165,516226,1016193,328860,190047,1004926,266384,197115,492585,857225,670884,80436,780941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]