SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548241 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548241 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802106,989079,39233,87195,179222,787411,175458,557674,425189,957394,1010111,141654,233713,324161,777415,477887,608777,419630,640559,260895,604585,65106,965920,976287,133492,779653,113162,371171,306076,403418,21655,442029,823103,213201,80818,671210,260506,830951,838674,857300,488959,804330,596379,276234,710412,586514,978110,420662,855067,739077,550142,269290,38942,329128,991130,11176,859263,894535,349448,529291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]