SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806791 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806791 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203355,5397,32172,47348,192538,759086,19999,527023,247801,340321,166959,1020301,183850,757629,400822,1019622,512243,581172,610237,445057,771515,566321,749427,374442,852513,788936,334211,428933,982575,656636,775808,150263,356855,137898,482603,903010,228630,529786,923080,862138,519737,48794,342131,544176,744968,494794,270794,291395,799483,1023522,898928,854373,60482,836717,115118,290731,1040619,41241,676797,98851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]