SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494847 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494847 [ RunTime:0.004827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437904,40635,860040,392411,778041,15643,327887,113398,1026014,542072,344754,33205,863259,711175,31803,990487,974568,848905,408258,723483,732009,896615,149904,542007,367421,761966,927793,130354,398622,148158,409651,167776,136198,126999,109387,1037045,808400,200217,988609,733365,181051,902799,844709,282633,544217,308940,776396,901961,818452,231386,293991,889066,602600,698866,485424,721334,239401,459580,980407,262494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001740s ]