SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318866 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318866 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112370,910914,531982,682498,536272,1000349,633945,454614,180424,327919,433904,79367,964187,606229,994171,391478,630341,6628,338016,561565,661572,393864,433030,256316,467970,31552,669610,1003660,676267,539878,128325,424765,1040960,449100,788420,773042,447562,787818,719856,347802,814258,107848,141461,887233,464725,32245,278366,957895,77923,222033,356764,305144,199280,638828,61759,466961,512705,135540,377013,801475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318866 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318866 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]