SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 273381 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 273381 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431160,43368,490412,501487,830748,508749,369754,332221,135594,410484,962614,554679,249046,557463,421447,852622,519837,908374,891286,699656,401499,463236,443624,263402,182867,129971,274993,821745,632005,878,671963,642485,772017,43224,536028,149270,832949,827832,538252,851410,27465,748991,655354,94711,161696,7450,239817,443937,238922,982875,174997,995141,877949,554535,157557,441154,427498,777068,312324,432341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 273381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 273381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]