SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343043 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343043 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928253,437756,769254,291643,603694,9116,299369,905749,1026896,321909,101664,690165,1033071,937222,536325,800258,360646,168355,990264,56471,936535,645543,375357,108823,829975,551464,123494,866223,305790,989721,952821,127752,289451,249678,981937,805940,713274,496454,422105,286672,251044,697310,441812,401075,1025839,6746,716951,658527,222340,563840,694013,309435,187402,616400,705034,233167,150017,1017853,25929,384038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]