SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466822 LIMIT 1 [ RunTime:0.001117s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466822 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022212,582932,542591,627710,171035,789829,676770,790693,898751,46036,260208,544651,885432,480534,244843,482209,547540,922662,605553,549076,142734,918433,595003,894238,308688,58299,795395,315078,581581,497252,447755,748120,501594,309122,187002,961431,423043,1012486,8561,45213,1019555,740824,470883,283533,565409,110104,210632,300506,375219,580405,206229,660438,44457,173957,916091,644180,704906,341877,898246,906522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002775s ]