SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294887 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294887 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010782,924662,485262,643891,106032,437660,581905,1009765,363375,149169,172247,834608,783213,591845,139298,900243,146063,855723,957672,224075,1030915,907131,417192,115687,817092,635147,37415,644180,746440,885275,92384,1010310,521563,480708,670522,179975,245179,179265,676332,262781,590736,804057,515081,642559,782325,277727,829444,161325,151534,434168,735378,997430,590497,746166,808644,235548,682104,292789,398201,643982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001177s ]