SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381015 LIMIT 1 [ RunTime:0.004029s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381015 [ RunTime:0.001313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645580,228728,979063,490198,895204,446966,467081,602866,223666,514799,44752,1024444,1040592,214109,55217,391283,213219,1044021,342696,32702,934299,954012,20692,752000,858502,328713,193561,564798,916796,207257,476310,793069,680143,36247,136310,261576,225652,843771,291928,213644,727256,532515,812041,926745,782871,961835,257076,521302,417450,625859,419485,820509,983187,765991,274095,111647,58140,171038,384608,58895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]