SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206860 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206860 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499603,54107,906438,111696,471855,649613,744925,1013010,125791,150866,133746,748818,100481,11945,580054,592366,954982,78905,767367,686125,251018,538369,99101,763744,816511,913813,315476,508315,835145,53060,978584,465067,541911,12433,412556,658921,890500,818667,867077,1022525,353166,400889,749492,168826,730175,785778,418534,141859,370115,545426,867359,367845,231333,533520,795643,722746,809631,992649,471476,194032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]