SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49571 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49571 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68042,867504,72563,677178,387372,673405,828304,519636,370666,606311,170768,479786,336660,629170,855669,549334,807096,124255,590682,155050,249582,982288,163543,730471,1011132,599451,1000833,254558,354218,939676,930046,107146,287130,699945,388434,1037767,1015795,1007826,443782,290094,174320,295031,601520,896544,749401,399552,996105,929438,378148,516403,625040,250316,381738,1007491,259085,153405,750409,242892,307342,79642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]