SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465045 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465045 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440021,311183,160108,1022342,824967,579980,5263,583317,354571,346210,746972,351644,932644,260695,706037,591873,566693,767126,574484,547086,140434,351086,170672,19465,685746,801544,455397,471001,704814,213550,712173,362516,820103,584391,374007,293703,412024,345001,930325,61394,882594,354533,528169,815422,228227,49660,1016093,509387,235510,266669,236154,326597,389265,831234,722531,444552,381411,360686,464624,681049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]