SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007899 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007899 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516184,177872,575491,13940,842049,341619,594516,580729,338370,759959,203697,303877,963148,913649,596126,88389,169426,74960,802592,119507,165773,493435,1009971,879761,376155,469985,347349,421170,32554,498481,533219,811698,269176,1031458,450969,740092,437686,23690,934828,749390,1044751,265235,1042548,353451,352901,650834,81810,200835,750406,137398,950391,927591,305011,2735,580808,425674,748697,349002,544696,870993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001411s ]