SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320624 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320624 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552457,455654,169965,307785,794273,464899,839225,285108,607318,818405,520346,979215,267249,415829,315797,909046,237887,278534,409110,889482,135589,376148,501993,377519,453320,1042815,472560,697157,1020029,608680,895702,601753,225317,908123,715900,154130,492411,60762,314211,608002,403945,632947,715914,337860,210197,889218,704020,983259,155186,1030665,166164,97862,793862,428248,129465,607939,1041545,621195,36378,123867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]