SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041393 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041393 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331572,697102,263669,553161,198201,708323,714456,540909,406862,770009,1028343,369416,152533,821220,473160,742985,450840,862096,887605,540967,743654,416359,810415,312926,462926,378310,980994,671995,386196,826777,217064,734849,961366,147913,618879,410423,755486,862630,294525,710493,325454,915236,208913,690312,1006628,1000057,406315,397043,492337,515482,1014587,607111,105694,374377,861556,894014,745908,684974,335324,555113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]