SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454354 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454354 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265126,476622,1032042,323610,661714,579839,463869,283731,731267,331212,783031,355791,387523,137082,437146,168598,1044186,76284,1042208,981531,518119,184048,334357,717735,703332,588116,99517,607176,79271,906972,220424,421427,38354,308578,706346,351301,1038326,546538,982112,936753,2907,730308,714587,432156,1012836,166808,607124,1009352,368787,224537,247989,430540,490293,190940,5683,499874,945238,714019,596838,958192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000909s ]