SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002679s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395262 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395262 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115282,923836,840713,773434,419771,318982,1036030,399756,657841,1008658,120407,952860,89517,28789,1000849,401793,351815,478996,355173,976740,649044,91241,624993,92148,118765,557890,468111,217357,694315,299567,441612,145719,624899,229922,636854,566368,454193,1048662,83369,443893,190509,398386,372663,715692,33420,980879,156242,1027287,688366,504687,316697,938211,15070,200619,298285,195583,742159,874905,322334,834040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]