SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43137 LIMIT 1 [ RunTime:0.001199s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43137 [ RunTime:0.003741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299183,151764,635552,263780,386123,457098,100579,606587,794660,191467,982921,239998,249086,632987,858105,68477,843950,670521,115561,265735,283606,676657,639936,642430,161419,611048,1029564,663931,370812,378499,649936,389050,156475,348789,1020402,886251,523606,30290,173898,843929,625349,581155,113306,998817,323929,504898,491432,997663,934270,70285,396695,844490,126015,337183,1024664,166997,865209,1046241,818168,199643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43137 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43137 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001553s ]