SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003920 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003920 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598078,804351,1004254,511196,108408,586947,327997,695736,776296,192537,495824,912477,136759,216228,592363,233207,232784,757377,401568,370633,997020,499942,459160,593242,278111,27001,561391,884049,852385,525799,922753,354633,1020322,710141,905977,644917,1046908,566305,828097,722769,151155,901374,229447,702620,10019,873633,28197,102341,972829,576886,312827,188845,958191,752249,185806,228071,30485,104398,381997,722365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]