SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381143 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381143 [ RunTime:0.003487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183530,850072,1036117,533661,904701,336184,561729,601761,153338,367245,483868,908027,595718,790932,744682,1016805,31744,765328,342818,379413,327562,222281,776683,523940,796913,319844,637288,338748,684679,105614,472935,713260,815724,886231,755855,459712,914283,391869,814088,145686,948666,99946,591349,388183,860259,153775,347801,208113,488632,455267,217410,107934,23694,482279,456087,357976,862003,440467,400362,927943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001179s ]