SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380422 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380422 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630189,666896,663426,465034,13811,990702,708291,495453,170406,869026,136046,875611,34281,153104,787838,1016962,754914,413341,353918,577448,895371,25558,243822,480088,16588,879965,980002,398834,210207,225686,321022,541344,771542,165745,1048298,544121,200222,178774,92554,1036535,571454,575873,48836,675943,747356,61740,98421,542819,273274,978431,384,42867,288242,974290,556981,842783,271036,374447,893370,1000868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001046s ]