SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101120 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101120 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368747,1001109,843113,655037,711234,416145,996546,1001065,857875,387498,924302,803476,729727,93506,946531,352515,197927,634523,371878,815980,194933,19160,682313,713503,913180,176887,147069,50002,308031,1034148,886448,394972,159671,687622,106713,528487,245095,599972,1015620,1035935,296940,674658,125028,811148,515004,228316,468457,484261,884098,991413,795511,87024,567041,215146,589918,776068,403415,802239,757855,437922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]