SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037821 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037821 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566068,1018921,167650,274462,476738,279583,117172,929629,13327,834846,1003682,193908,832498,918337,693001,979526,344415,705143,716657,852503,620795,229518,898218,857216,535880,196850,360335,799960,492543,161864,772370,168070,617461,837018,884724,169248,110505,678547,937937,114114,657240,986996,842072,905528,286766,457256,937692,542697,684537,677568,717838,337564,900906,585619,419177,543543,951839,111422,1031396,321870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]