SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102871 LIMIT 1 [ RunTime:0.001586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102871 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580539,715145,706441,991613,203935,444500,574461,855652,626760,760855,850604,15048,634540,523515,695615,601017,164402,31299,821574,687226,601556,260755,1011901,176164,578759,544019,609379,104309,856170,693645,1034105,780396,377316,952595,263331,465963,665277,625043,231731,53479,688362,63279,421665,633102,311232,158034,491150,359588,529732,266016,223351,212193,455245,912165,332031,753119,679849,497982,3543,481267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002689s ]