SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264311 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264311 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372744,691890,892578,705747,798942,769106,212374,527779,376989,483077,763655,807465,861222,1022312,495999,878121,312771,673264,801438,237424,426863,558582,700561,321202,1029881,177430,38749,974461,23846,465288,199712,656756,269761,360970,1008094,225269,857388,752561,128540,183464,582239,596834,312688,861104,880636,914967,50950,737044,309005,785088,542402,781250,485930,849166,30269,712618,1025877,286051,705425,929382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]