SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038097 LIMIT 1 [ RunTime:0.001090s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038097 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766541,463387,284865,437643,823468,15478,624247,1014207,80062,404213,604351,738153,674474,165865,171478,252471,859677,441788,660749,417369,397885,604877,670640,391211,490155,643426,910880,435420,994465,147219,980058,596868,588415,129747,896941,22833,886689,32579,720333,216034,795515,972590,812263,109417,400897,690266,869452,397438,234625,292428,82865,188411,553091,992921,340512,1033141,102204,20813,180583,1028916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]