SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028105 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028105 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530328,1821,220897,434429,778982,925203,39380,304658,92313,405073,564878,709339,768604,650613,56575,444868,410303,984763,86822,365746,650925,477200,533593,521258,1023867,552680,846160,330007,83115,88406,572051,226393,176442,789567,806078,952107,403400,546634,115409,581677,670048,485478,819844,1012357,480422,960535,127714,346779,478705,609117,52814,680463,498077,881055,449980,651594,480955,614975,777249,875820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]