SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281870 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281870 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958462,876639,980543,147950,402843,126509,99912,182904,746895,606889,207018,130567,731156,802171,135071,124653,380799,892064,588719,90252,677321,283253,15132,126286,678939,224062,379283,920673,403748,299625,168461,31945,850738,919295,342370,231063,205403,115435,531175,555569,467766,818508,920090,716187,734589,521386,859271,896499,129011,801405,327837,159739,814984,879964,401389,836732,659568,404450,74566,249188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]