SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023013 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023013 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588296,499280,17055,1020816,283279,862415,198215,852349,315746,1001252,809486,492675,298519,52330,599278,959754,831455,820151,178415,549943,674521,863661,85368,637866,975364,385858,645661,843329,374578,35098,684307,884283,417149,753883,179586,285809,857476,152650,451350,75779,80454,230292,620652,865509,128257,806128,864932,31862,1044159,197641,1033692,231429,756883,148482,310919,200315,945753,746558,593447,814644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]