SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801106 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801106 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76202,562848,427660,127209,845632,341868,740876,84468,156722,280250,824021,774291,23853,120546,121559,113383,831443,398608,674844,795846,334358,26668,447727,280413,1015741,890655,410322,231146,647940,700992,906856,187602,566089,518803,569361,942363,235463,346032,290956,360177,979130,361395,723226,682747,799285,971016,736233,162474,438445,336248,704419,674508,946897,195,801102,302493,771145,73148,303303,362671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]