SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50103 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50103 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487333,764895,841759,983847,421406,86775,599,452679,286778,321491,325263,277834,769367,494130,911229,762306,483730,1001145,150426,416554,130950,451742,1031357,528940,848339,772295,995478,345874,374940,360073,924823,618609,982699,643585,65165,5187,185798,834315,39805,651407,580342,308339,602947,593120,443450,1036241,374192,484833,850712,388470,335796,373880,228767,863060,197724,175,1030189,1008307,134275,1043938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]