SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556518 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556518 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557668,347631,230126,940518,640595,441763,737826,72586,562201,289138,917841,149133,182790,729823,195653,694575,569602,583812,843806,420465,405022,303824,258917,288528,2520,180805,97695,470406,516566,508612,625090,55713,155899,102073,644304,878892,977176,499660,960108,256932,902423,332368,1005171,898088,893674,242367,634381,948315,672042,1015068,255321,243980,190735,904970,514485,772167,332140,127778,233267,49136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]