SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 891201 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 891201 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015857,443637,45693,895684,289696,715459,903921,930078,1011363,23172,736999,101953,846192,555526,511263,712999,49160,158644,903891,353337,615237,801748,898288,470617,923982,823963,592686,52282,729826,203073,67019,534140,739029,177079,749696,150026,581150,1004157,749926,685013,581445,952808,332850,382990,492807,128281,504618,945104,341839,914508,776605,179923,1034857,303728,488645,804671,136286,44764,815233,192221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 891201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 891201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]