SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545422 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545422 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954193,920078,253875,644732,893017,862437,525464,70101,438675,216595,378933,997859,742789,131228,358408,285198,329036,801622,441243,449605,1016813,301660,727535,868346,664246,19668,707177,862170,240116,417348,492761,703292,144993,932078,976528,873178,219570,680562,107404,395708,328218,27336,588630,34979,210980,688698,261227,9021,791825,389986,650566,182368,401094,382054,741999,686040,320026,355421,19269,333660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]