SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104496 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104496 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6523,539509,71028,996189,694857,755655,260713,956092,908549,156702,756385,660373,601708,70310,691172,44971,728765,411531,515602,526485,436269,877555,834538,415318,577924,412331,852808,963344,707645,343844,63043,436587,403724,165588,254370,714783,945799,780376,294192,271314,735407,377494,9319,1019360,373898,349442,858438,493907,146906,544151,577133,955003,662997,25580,44338,130064,446052,215837,900717,838030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]