SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010401 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010401 [ RunTime:0.008987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17216,28213,886222,592260,209268,958110,220230,315308,7900,799000,253231,139465,152266,549181,748974,986613,525573,895069,307773,220309,317538,360345,156773,607192,194462,222054,1025695,177576,980321,933495,289359,500618,362236,637578,500370,1004852,125039,871890,897238,873991,253443,214142,303712,732172,874260,759189,497922,220950,687403,415302,429057,389674,520684,137903,487217,451607,1043758,791092,237146,62309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002224s ]