SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043246 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043246 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239240,413323,698933,854123,461928,896592,3425,184613,693319,192785,414690,915657,500183,664513,320648,403275,534604,169814,654951,282317,1045083,748063,392567,472403,127462,970540,112813,568329,118019,744630,142272,176519,777438,444503,176281,631591,971783,72406,80590,733133,475224,1011425,295639,239830,793042,238749,126604,529866,917871,631909,182452,900201,323298,427944,609266,528054,835752,107164,772811,321987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]