SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80738 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80738 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624013,507779,572884,432679,682480,333202,419021,435038,309011,21852,333467,991495,917607,169461,160846,42577,954641,587872,222808,905154,565039,591690,288947,477521,67165,6310,152123,346342,977172,253404,452917,331877,979961,903968,768264,155103,431416,625573,1021770,521529,159021,545592,355700,181880,810583,956764,1015892,488010,155122,336132,221078,608785,257250,623496,549659,178494,834051,684195,270315,886814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]