SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191092 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191092 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897919,353277,411821,69142,430733,334229,225607,304041,435485,743417,1002813,296419,291236,824792,1040205,92698,134677,269682,607981,207300,413866,529832,185375,682888,243789,370477,451324,244801,659011,475379,927742,807039,709436,136365,491728,167761,574335,183568,201389,581654,128433,415685,806720,475536,565316,93308,326769,194048,562892,996285,838581,64244,898616,990157,480551,46341,439698,544494,311905,732942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001889s ]