SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017435 LIMIT 1 [ RunTime:0.001914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017435 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107331,162749,135022,750300,311270,246958,746607,446076,562651,913175,940021,121033,326832,902528,891335,335736,161525,324811,156935,119375,932956,91161,129546,149314,965155,553483,926703,363680,577777,448422,210676,699581,753741,483044,431469,188754,936654,951060,515675,253385,641665,205489,953458,362679,867594,952906,312,56176,135485,5273,649653,306582,1031319,303695,985093,359362,634694,986105,502378,215376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001034s ]