SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004383 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004383 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782243,1029380,872484,372622,579317,421804,248695,243876,777147,341254,800190,315096,938186,595066,727521,136531,138630,685740,664272,254112,716078,739548,139706,228116,1018974,210267,442348,642927,161150,422016,590857,839737,303454,47106,216597,46781,423857,775160,638293,533164,883292,838297,1029544,861342,23086,1020170,605001,288696,3336,847625,752552,770833,113084,639532,184545,509902,598675,22787,711485,513008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]