SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525711 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525711 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121041,796068,673058,147254,160257,190539,870389,127965,362965,156675,1030984,338270,460428,126818,87847,96614,843603,1017734,728269,50340,434951,57102,614547,703168,228086,326921,473928,63851,378072,232521,400947,524811,786353,123741,573545,393858,888641,781621,308623,83150,834500,52015,606234,207518,701553,436506,554499,42269,700366,335312,393146,928798,243913,594928,600855,749589,785325,922195,740381,909906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]