SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519812 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519812 [ RunTime:0.002953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470646,796940,229336,362221,1028243,1012849,707892,900084,21747,674444,518204,867773,909131,937409,551112,846007,804080,256785,330099,557833,201322,625538,133361,288908,948116,684799,20825,19646,568802,495417,574664,245918,64628,168147,556297,723512,684652,628793,497155,821118,415469,734461,443055,416065,545021,939296,541769,792775,801589,1032651,670453,184290,450635,360894,779655,335078,611968,711321,726129,939568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]