SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356040 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356040 [ RunTime:0.002616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70202,67822,97975,623146,778320,65440,754098,72466,364276,219211,671038,508836,497166,628740,194747,580264,973186,350690,371690,268499,202889,656989,501961,918398,152161,824272,474545,131255,939848,458054,276513,438711,860525,111586,146134,897461,185989,249043,670824,839882,251041,864860,932867,114166,595378,238557,95147,456593,899341,506087,392253,998135,1001895,420243,741279,446847,830692,726890,544839,28752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001108s ]