SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149480 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149480 [ RunTime:0.002736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173948,980306,1005423,850563,896710,1020848,576559,119016,836743,422628,616949,403131,861229,761335,966038,235794,579034,774706,588726,399479,355210,610376,550669,658754,360851,225896,639867,1019560,9785,428670,950258,564879,199397,1040386,891782,406605,742488,949722,729279,620428,44342,91177,951625,58574,904712,193127,354273,88627,221687,31519,541419,609600,1008701,211503,387687,421281,523313,822094,943832,1013674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000799s ]