SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195171 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195171 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688903,467949,446783,601497,766628,622813,185668,858171,539977,192781,789400,574979,521784,541918,739022,868040,734444,167791,642742,38254,648349,422811,593381,446771,109277,781240,350895,673425,620749,12752,146947,391036,118320,680410,221041,940392,811840,791851,927760,624527,848879,32595,99141,379222,319855,725656,108633,335819,508826,701975,636598,588084,579650,87538,765827,572740,877876,436947,386880,578116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]