SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046570 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046570 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856204,629916,650880,168096,759640,77173,754210,755899,18791,407295,1026557,125757,20528,522292,886739,910576,410395,147853,695316,644588,267959,739862,364746,648473,807350,480836,332902,124102,859901,814167,454374,499949,819729,245602,243720,867066,792777,246374,505847,450268,1039767,225847,115438,924376,369328,445837,555259,422584,661105,640541,835127,209211,732620,985087,215904,956423,338545,993082,642444,924814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]