SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541923 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541923 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434974,81444,386213,730914,215006,817194,21544,988517,646779,40730,412270,61850,1025564,80879,932224,663020,157497,281783,522555,836945,634402,413361,126875,758796,954648,94036,479827,597964,178719,692299,666807,207955,599694,432548,293795,811645,967470,876013,379135,566326,113772,316241,292562,34458,480629,721640,723261,894294,29456,295269,770949,454070,557813,425314,797433,313629,445459,49586,905876,654121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]