SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20126 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20126 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044697,583147,556379,187108,464977,285725,522652,206604,1011403,433956,16932,185389,195329,889049,864184,248061,246275,499721,809997,25344,852746,458422,263407,353040,9423,421296,1033102,279280,295225,500346,89041,849513,317685,169104,9193,551159,354144,654567,178495,49704,75544,716749,598223,776926,768491,289959,219261,125434,995282,285369,678675,792516,380012,674675,893503,772763,275495,106829,723762,444162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]