SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405398 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405398 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643160,515208,466900,1946,864421,474764,894067,668914,688680,1037947,41251,687097,564468,970299,445932,429872,544855,389031,528407,821552,999189,938143,521481,288056,568884,716511,752268,520260,63533,611108,89928,776127,471212,454008,669486,154356,80005,1263,782404,417933,553203,389467,578164,481599,506139,385772,531555,189618,806807,455736,365669,386135,595998,468367,422418,191734,137527,891793,352618,1026098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]