SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505396 LIMIT 1 [ RunTime:0.004753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505396 [ RunTime:0.005430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974940,428328,480992,133913,648704,444123,195334,346203,462596,855657,192677,107992,921978,749809,872570,692887,1026794,634573,596127,981821,591937,166870,726105,303005,184280,849618,279955,528963,54491,1028381,620222,1036206,386686,1029522,919328,1008399,452932,1048818,689407,662285,457916,792829,987040,794005,260575,991201,854950,543505,721562,209308,788928,877185,532120,81879,1042410,894721,852628,410973,889474,73717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]