SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50480 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50480 [ RunTime:0.001357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623661,692694,976133,622324,64835,234398,923363,1026220,403844,478960,42345,692430,347503,746658,636403,482075,336652,630344,524057,266463,700585,463773,959711,749581,591199,176291,685604,651149,936652,447078,21687,664876,251252,679665,629251,819957,959579,109717,230589,450710,65271,202339,274374,781254,594523,35180,926629,842988,542144,583367,321809,36065,3213,58595,333010,1028306,789374,352351,100414,380396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]