SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42157 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42157 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224744,362412,107753,449920,232935,114425,323387,565348,1034015,805165,309901,424785,441275,593223,180500,577533,518388,106792,20644,422029,92961,834174,509986,456659,536113,587590,200477,343040,468434,279928,912013,863236,351194,346509,997400,3550,861956,214831,304926,1014869,333547,545910,332500,313146,979952,754556,170247,728051,435259,2603,105732,451109,62518,611938,785664,322816,153519,915339,383573,1010717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]