SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26606 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26606 [ RunTime:0.005442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55492,1025406,473115,585319,425716,791498,352199,440094,3372,116835,499661,753114,224937,126247,211108,185749,109162,421186,1023275,1019394,566662,852340,776095,484942,182872,794356,910231,292257,950850,576031,9512,755725,197844,128792,240758,998478,321436,434120,493481,1039479,532227,470018,44675,133881,695079,107469,888334,555067,210691,266506,964150,246067,418889,199290,60934,191023,329533,362509,76452,300236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]