SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015018 LIMIT 1 [ RunTime:0.000711s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015018 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383661,521904,107005,490764,697480,66170,745616,734616,1026009,996126,305173,1020357,898322,1029537,250378,806666,984276,244830,769669,327423,685604,417078,687273,620618,60365,744852,492705,333132,195662,487522,217671,892215,142316,1021934,884240,956521,29618,591027,690387,81487,62082,231105,440050,612325,474158,661255,553009,211961,278730,724472,324257,798320,463116,327072,26455,958041,764770,886805,256452,112621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]