SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325904 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325904 [ RunTime:0.005573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465089,722824,591790,491388,583146,827523,865529,113206,543981,419093,214948,335732,558415,336724,1032097,468639,183518,874730,959005,183621,592682,776212,275097,747718,887137,309917,51060,29381,632304,174814,219957,961607,253299,609094,122849,505885,679242,499855,5193,39464,194740,608009,149084,136552,601892,68943,24499,407632,491554,660061,124642,448788,398758,735725,688970,328572,311198,1035639,54314,449926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]