SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255409 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255409 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325509,417346,298951,1042399,225866,137600,623417,742135,393315,228428,449699,1033388,334023,487703,411487,793274,81454,1006816,43672,913975,146293,368769,243676,117070,98339,786715,681372,200611,989896,562725,738885,153401,40497,202031,48803,994571,446758,868363,544143,870130,433223,206605,673337,712091,691491,132406,845152,159337,656595,189482,889280,755205,726009,385084,813491,213428,344747,99119,150905,853501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]